-- created by kumiler
-- on 2023/4/10 14:09
-- DESC

CREATE external TABLE jms_dim.`dim_sys_area_info_jt`
(
    `id`                bigint ,
    `area_info_code`    string  COMMENT '片区编码',
    `network_code`      string  COMMENT '管辖区域编码',
    `network_name`      string  COMMENT '管辖区域名称',
    `next_network_code` string COMMENT '下级管辖区域编码',
    `next_network_name` string COMMENT '下级管辖区域名称',
) COMMENT = '片区信息管辖区域表'
stored as parquet
LOCATION
'/dw/hive/jms_dim.db/external/dim_sys_area_info_jt';
